Problem Note 40485: Parsing problems occur when you create a calculated variable in the SAS® IT Resource Management plug-in for SAS® Data Integration Studio
 |  |  |  |
In the SAS IT Resource Management 3.1.1 plug-in for SAS Data Integration Studio, the code generation for expressions wraps the line whenever a semicolon (;) is used. This issue occurs even if the semicolon is inside of quotation marks (";"). The semicolon causes parsing problems when you create a calculated variable.
When a semicolon is needed inside of quotation marks, use the hexadecimal format for a semicolon (that is, 3B in ASCII and 5E in EBCDIC). For example:
upcase(scan(qwhccv,1,"3B"x))
If several characters are needed in the scan-for value (for example, a comma and a semicolon), then concatenate the comma and the hexadecimal value, as follows:
upcase(scan(qwhccv,1,"," !! "3B"x))
This problem is planned to be corrected in SAS IT Resource Management 3.2.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS IT Resource Management | z/OS | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 3.1.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Datacenter Server | 3.1.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 3.1.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 3.1.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 3.1.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista for x64 | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| HP-UX IPF | 3.1.1 | 3.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-08-30 10:48:48 |
| Date Created: | 2010-07-29 14:21:22 |